﻿CREATE TABLE [dbo].[DescuentosRecargosFechasHoras] (
    [IdDescuentoRecargoFechaHora] INT             IDENTITY (1, 1) NOT NULL,
    [Nombre]                      VARCHAR (50)    NOT NULL,
    [Observaciones]               VARCHAR (500)   NOT NULL,
    [FechaDesde]                  DATE            NOT NULL,
    [FechaHasta]                  DATE            NOT NULL,
    [Lunes]                       BIT             NOT NULL,
    [Martes]                      BIT             NOT NULL,
    [Miercoles]                   BIT             NOT NULL,
    [Jueves]                      BIT             NOT NULL,
    [Viernes]                     BIT             NOT NULL,
    [Sabado]                      BIT             NOT NULL,
    [Domingo]                     BIT             NOT NULL,
    [HoraDesde]                   TIME (0)        NOT NULL,
    [HoraHasta]                   TIME (7)        NOT NULL,
    [DescuentoRecargo]            DECIMAL (19, 4) NOT NULL,
    CONSTRAINT [PK_DescuentosRecargosFechasHoras] PRIMARY KEY CLUSTERED ([IdDescuentoRecargoFechaHora] ASC)
);

